package com.neusoft.work.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.neusoft.work.po.CareLevelProject;
import com.neusoft.work.po.CareProject;

public interface CareLevelProjectDao extends BaseMapper<CareLevelProject>{
    @Select("""
  	      SELECT p.*
  	        FROM CareProject p
  	        JOIN CareLevelProject lp
  	          ON p.id = lp.careProjectId
  	       WHERE lp.careProjectId = #{levelId}
  	      """)
  List<CareProject> selectByLevelId(Integer careLevelId);
}
